/*
 Navicat Premium Data Transfer

 Source Server         : Local_MySql
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : security

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 13/07/2021 07:25:37
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `open_id` char(64) DEFAULT NULL COMMENT '社交',
  `phone` char(11) DEFAULT NULL COMMENT '手机',
  `password` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `age` int DEFAULT NULL COMMENT '年龄',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `role` varchar(255) DEFAULT NULL COMMENT '角色',
  `permission` varchar(255) DEFAULT NULL COMMENT '权限',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1414161049346756620 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1414161049346756611, 'mike', 'mike_open', '666666', 'mike', 18, 'mike@zf233.com', 'admin|user', 'select|update|remove|select');
INSERT INTO `user` VALUES (1414161049346756613, 'rose', 'rose_open', '888888', 'rose', 20, 'rose@zf233.com', 'user', 'select|update|insert');
INSERT INTO `user` VALUES (1414161049346756616, 'lisi', 'rose_open', '888888', 'lisi', 20, 'rose@zf233.com', 'user', 'select|update|insert');
INSERT INTO `user` VALUES (1414161049346756617, 'wangwu', 'rose_open', '888888', 'wangwu', 20, 'rose@zf233.com', 'user', 'select|update|insert');
INSERT INTO `user` VALUES (1414161049346756618, 'zhaoliu', 'rose_open', '888888', 'zhaoliu', 20, 'rose@zf233.com', 'user', 'select|update|insert');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
